﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MiniExcelLibs.Attributes;

namespace DFGK_WMS.Model.Exports
{
    public class InventoryExport
    {
        [ExcelColumnName("库区名称")]
        public string AreaName { get; set; }

        [ExcelColumnName("货位名称")]
        public string LocationName { get; set; }

        [ExcelColumnName("状态")]
        public string Status {
            get; set;
        }

        [ExcelColumnName("垛条码")]
        public string PalletBarcode { get; set; }

        [ExcelColumnName("备注")]
        public string Remark { get; set; }

        [ExcelColumnName("物料号")]
        public string MaterialCode { get; set; }

        [ExcelColumnName("物料名称")]
        public string MaterialName { get; set; }

        [Column(TypeName = "decimal(18,2)"), ExcelColumnName("库存数量")]
        public decimal? AvailableQty { get; set; }

        [ExcelColumnName("计量单位")]
        public string UnitName { get; set; }

        [ExcelFormat("yyyy-MM-dd"), ExcelColumnName("入库时间")]
        public DateTime? InStockDate { get; set; }

        [ExcelColumnName("批次号")]
        public string BatchNo { get; set; }

        [ExcelColumnName("供应商")]
        public string SupplierName { get; set; }

        [ExcelColumnName("客户")]
        public string CustomerName { get; set; }

        [ExcelColumnName("物料类型编码")]
        public string MaterialTypeCode { get; set; }

        [ExcelColumnName("物料类型")]
        public string MaterialTypeName { get; set; }

        [ExcelColumnName("ERP货位编码")]
        public string ErplocationCode { get; set; }
    }
}
